Release 10.1A: OpenEdge Data Management:
DataServer for ORACLE

ORACLE Utilities menu

The tools you need to create and maintain your ORACLE DataServer schema are found on the DataServer ORACLE Utilities menu. Table 7–1 briefly describes the contents of the menu. The sections which follow will describe each item in detail.

Table 7–1: OpenEdge DataServer for ORACLE Utilities menu 

Menu item	Function
Create DataServer Schema...	Create a schema image for an ORACLE database.
Update/Add Table Definitions...	Update the schema image to reflect any changes you made to the ORACLE data definitions.
Verify Table Definition...	Verify that the data definitions in the schema image match your ORACLE data definitions.
Edit Connection Information...	Change connection information or the logical database name in a schema image.
Change DataServer Schema Code Page...	Change the code page in a schema image.
Delete DataServer Schema...	Delete a schema image.
Run ORACLE SQL *Plus...	Modify your ORACLE database with SQL*PLUS commands.
Schema Migration Tools	Access utilities for migrating an OpenEdge database to an ORACLE database, incrementally migrating a schema to ORACLE, adjusting a schema image, and performing a bulk load of data.

When you access an ORACLE utility, you might see a dialog box for verifying your user ID and password. Choose OK, or enter a new user ID and password with the privileges required for creating and updating a schema image. See the "Schema holder security" section for more information.

Note: The DataServer makes an additional connection to the schema holder when it creates, updates, or verifies a schema image. If you are connecting to multiple databases or schema images, make sure that you set the Number of Databases (-h) parameter to a value that accommodates the number of databases and schema images plus one.